WorkbookReplace Method

Overload List

Replace(IListString, IListString) Replaces all occurrences of the specified oldText with newText.
Replace(String, Run) Replaces all occurrences of the specified text with a copy of the specified run. A cell which holds plain text is converted into a rich text cell, the text before and after the replaced text keeps its format.
Replace(String, IListRun) Replaces all occurrences of the specified text with copies of the specified runs.
Replace(String, String) Replaces all occurrences of the specified oldText with newText in the whole workbook. The format of the cells and the properties of all runs remain unchanged. Formulas are not changed.
Replace(IListString, IListString, FindOptions) Replaces all occurrences of the specified oldText with newText.
Replace(String, Run, FindOptions) Replaces all occurrences of the specified text with a copy of the specified run.
Replace(String, IListRun, FindOptions) Replaces all occurrences of the specified text with copies of the specified runs.
Replace(String, String, FindOptions) Replaces all occurrences of the specified oldText with newText.

See Also